package com.hanserwei.mapper;

import com.hanserwei.entity.Student;
import com.hanserwei.entity.StudentAvgScoreDTO;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface StudentMapper {
    Student selectStudentWithScores(Integer id);

    List<Student> findAllStudentsWithScores();

    List<StudentAvgScoreDTO> findStudentAvgScores();

    List<Student> findStudentsByCriteria(
            @Param("name") String name,
            @Param("age") Integer age,
            @Param("gender") String gender
    );
}
